package com.hrm.mapper;

import com.hrm.pojo.Notice;
import org.apache.ibatis.annotations.Mapper;

import java.sql.SQLException;
import java.util.List;

@Mapper
public interface NoticeMapper {
    int deleteByPrimaryKey(Integer id)throws SQLException;

    int insert(Notice record)throws SQLException;

    int insertSelective(Notice record)throws SQLException;

    /*根据 公告名称 和 公告内容 查询所有对应公告*/
    List<Notice> selectByTitleAndContent(Notice record);

    Notice selectByPrimaryKey(Integer id)throws SQLException;

    Notice selectByTitle(String title)throws SQLException;

    int updateByPrimaryKeySelective(Notice record)throws SQLException;

    int updateByPrimaryKeyWithBLOBs(Notice record)throws SQLException;

    int updateByPrimaryKey(Notice record)throws SQLException;
}